<?php 

//column settings for variable_id
$fieldspec['variable_id'] ['show'] = 1;
$fieldspec['variable_id'] ['key'] = 1;
$fieldspec['variable_id'] ['size'] = 20;
$fieldspec['variable_id'] ['rows'] = 1;

//column settings for variable_name
$fieldspec['variable_name'] ['show'] = 'E';
$fieldspec['variable_name'] ['select'] = 'T';
$fieldspec['variable_name'] ['size'] = 20;
$fieldspec['variable_name'] ['rows'] = 1;
$fieldspec['variable_name'] ['add'] = 1;

//column settings for type
$fieldspec['type'] ['show'] = 'E';
$fieldspec['type'] ['select'] = 'T';
$fieldspec['type'] ['size'] = 20;
$fieldspec['type'] ['rows'] = 1;
$fieldspec['type'] ['add'] = 1;

//column settings for quote
$fieldspec['quote'] ['show'] = 'E';
$fieldspec['quote'] ['select'] = 'T';
$fieldspec['quote'] ['size'] = 20;
$fieldspec['quote'] ['rows'] = 1;
$fieldspec['quote'] ['add'] = 1;

//column settings for project_id
$fieldspec['project_id'] ['show'] = 'E';
$fieldspec['project_id'] ['select'] = 'D';
$array_project_id_list = get_array_query("SELECT project_id AS keyvalue, project_name AS showvalue FROM projects");
$fieldspec['project_id'] ['list'] = $array_project_id_list;
$fieldspec['project_id'] ['filter'] = 1;
$fieldspec['project_id'] ['size'] = 20;
$fieldspec['project_id'] ['rows'] = 1;

//column settings for variable_size
$fieldspec['variable_size'] ['show'] = 'E';
$fieldspec['variable_size'] ['select'] = 'T';
$fieldspec['variable_size'] ['size'] = 4;
$fieldspec['variable_size'] ['rows'] = 1;

//column settings for source_id
$fieldspec['source_id'] ['show'] = 'E';
$fieldspec['source_id'] ['select'] = 'D';
$array_source_id_list = get_array_query("SELECT tablesource_id AS keyvalue, table_name AS showvalue FROM tablesources ");
$fieldspec['source_id'] ['list'] = $array_source_id_list;
$fieldspec['source_id'] ['filter'] = 1;
$fieldspec['source_id'] ['size'] = 20;
$fieldspec['source_id'] ['rows'] = 1;
$fieldspec['source_id'] ['add'] = 1;

//column settings for def_show_text
$fieldspec['def_show_text'] ['show'] = 'E';
$fieldspec['def_show_text'] ['select'] = 'T';
$fieldspec['def_show_text'] ['size'] = 4;
$fieldspec['def_show_text'] ['rows'] = 1;

?>